SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_ChiTietTour_ThongTinKhachSan]
	@MaTour CHAR(20)
AS
Begin
	SELECT  MA_TOUR, TEN_KS, DIA_CHI, DIEN_THOAI, WEBSITE
	FROM	TOUR_KS TKS JOIN  KHACH_SAN KS ON tks.MA_KS = ks.MA_KS
	WHERE	MA_TOUR = @MaTour
END

GO
